{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Name","Formula-1","Formula-2","Formula-3","Formula-4","Formula-5","Formula-6","Result",null,"Megaformula",null,"VBA Function"]
[" Bob Smith",{"$f":"TRIM(A2)","v":"Bob Smith"},{"$f":"FIND(\" \",B2,1)","v":4},{"$f":"FIND(\" \",B2,C2+1)","v":{"$error":"#VALUE!"}},{"$f":"IF(ISERROR(D2),C2,D2)","v":4},{"$f":"LEFT(B2,C2)","v":"Bob "},{"$f":"RIGHT(B2,LEN(B2)-E2)","v":"Smith"},{"$f":"F2&G2","v":"Bob Smith"},null,{"$f":"LEFT(TRIM(A2),FIND(\" \",TRIM(A2),1))&RIGHT(TRIM(A2),LEN(TRIM(A2))-IF(ISERROR(FIND(\" \",TRIM(A2),FIND(\" \",TRIM(A2),1)+1)),FIND(\" \",TRIM(A2),1),FIND(\" \",TRIM(A2),FIND(\" \",TRIM(A2),1)+1)))","v":"Bob Smith"},null,{"$f":"nomiddle(A2)","v":"Bob Smith"}]
["Mike A. Jones","Mike A. Jones",5,8,8,"Mike ","Jones","Mike Jones",null,"Mike Jones",null,{"$f":"nomiddle(A3)","v":"Mike Jones"}]
["Jim Ray Johnson","Jim Ray Johnson",4,8,8,"Jim ","Johnson","Jim Johnson",null,"Jim Johnson",null,"Jim Johnson"]
["Tom   Alvin   Jacobs","Tom Alvin Jacobs",4,10,10,"Tom ","Jacobs","Tom Jacobs",null,"Tom Jacobs",null,"Tom Jacobs"]
["John Q. Public","John Q. Public",5,8,8,"John ","Public","John Public",null,"John Public",null,"John Public"]
["R.J Smith","R.J Smith",4,{"$error":"#VALUE!"},4,"R.J ","Smith","R.J Smith",null,"R.J Smith",null,"R.J Smith"]
["R. Jay Smith","R. Jay Smith",3,7,7,"R. ","Smith","R. Smith",null,"R. Smith",null,"R. Smith"]
["     Tim Jones","Tim Jones",4,{"$error":"#VALUE!"},4,"Tim ","Jones","Tim Jones",null,"Tim Jones",null,"Tim Jones"]